
global path "C:\Users\wam21\Dropbox\Dropbox\Replication"

clear

import excel "${path}\Raw Data\NIPA\BEADepreciation.xlsx", sheet("Depreciation Rate") firstrow

keep Industry Average B M AD

gen Responsive = 1
replace Responsive = 0 if Industry == "Mining" | Industry == "Construction" | Industry == "Manufacturing" | Industry == "Finance and insurance" | Industry == "Transportation and warehousing"

sort Responsive

egen avgdepr = mean(Average), by(Responsive)

